eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_US_SQWL_ARCHIVE dependencies on PAY_PAYROLL_ACTIONS

Line 202: add the context of pay_payroll_actions

198: A_SS_EE_WAGE rate to archive the data
199: related to bug 983094 and 101435
200:
201: 01-sep-1999 achauhan While archiving the employer data
202: add the context of pay_payroll_actions
203: to ff_archive_item_contexts.
204: 11-aug-1999 achauhan Added the call to
205: eoy_archive_gre_data in the
206: eoy_range_cursor procedure. This is

Line 700: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;

696: /* Variables used to hold the details of the payroll and assignment actions
697: that are created. */
698:
699: l_payroll_action_created boolean := false;
700: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
701: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
702:
703:
704: /* Variable holding the balance to be tested. */

Line 738: l_report_type pay_payroll_actions.report_type%type;

734: l_jurisdiction_code varchar2(30);
735:
736: /* general process variables */
737:
738: l_report_type pay_payroll_actions.report_type%type;
739: l_report_cat pay_payroll_actions.report_category%type;
740: l_state pay_payroll_actions.report_qualifier%type;
741: l_report_format pay_report_format_mappings_f.report_format%type; -- Bug# 3843134
742: l_value number;

Line 739: l_report_cat pay_payroll_actions.report_category%type;

735:
736: /* general process variables */
737:
738: l_report_type pay_payroll_actions.report_type%type;
739: l_report_cat pay_payroll_actions.report_category%type;
740: l_state pay_payroll_actions.report_qualifier%type;
741: l_report_format pay_report_format_mappings_f.report_format%type; -- Bug# 3843134
742: l_value number;
743: l_value_sit number ; --4310812

Line 740: l_state pay_payroll_actions.report_qualifier%type;

736: /* general process variables */
737:
738: l_report_type pay_payroll_actions.report_type%type;
739: l_report_cat pay_payroll_actions.report_category%type;
740: l_state pay_payroll_actions.report_qualifier%type;
741: l_report_format pay_report_format_mappings_f.report_format%type; -- Bug# 3843134
742: l_value number;
743: l_value_sit number ; --4310812
744: l_person_on boolean ; --4349864

Line 764: pay_payroll_actions ppa

760: paa.tax_unit_id tax_unit_id,
761: ppa.effective_date effective_end_date
762: FROM per_all_assignments_f ASG,
763: pay_assignment_actions paa,
764: pay_payroll_actions ppa
765: WHERE ppa.effective_date between l_period_start
766: and l_period_end
767: and ppa.action_type in ('R', 'Q', 'V', 'B', 'I')
768: and paa.payroll_action_id = ppa.payroll_action_id

Line 802: pay_payroll_actions ppa,

798: paa.tax_unit_id tax_unit_id,
799: ppa.effective_date effective_end_date
800: FROM per_all_assignments_f ASG,
801: pay_assignment_actions paa,
802: pay_payroll_actions ppa,
803: pay_population_ranges ppr
804: WHERE ppa.effective_date between l_period_start
805: and l_period_end
806: and ppa.action_type in ('R', 'Q', 'V', 'B', 'I')

Line 841: pay_payroll_actions ppa

837: paa.tax_unit_id tax_unit_id,
838: ppa.effective_date effective_end_date
839: FROM per_all_assignments_f ASG,
840: pay_assignment_actions paa,
841: pay_payroll_actions ppa
842: WHERE ppa.effective_date between l_period_start
843: and l_period_end
844: and ppa.action_type in ('R', 'Q', 'V', 'B', 'I')
845: and paa.payroll_action_id = ppa.payroll_action_id

Line 879: pay_payroll_actions ppa,

875: paa.tax_unit_id tax_unit_id,
876: ppa.effective_date effective_end_date
877: FROM per_all_assignments_f ASG,
878: pay_assignment_actions paa,
879: pay_payroll_actions ppa,
880: pay_population_ranges ppr
881: WHERE ppa.effective_date between l_period_start
882: and l_period_end
883: and ppa.action_type in ('R', 'Q', 'V', 'B', 'I')

Line 921: pay_payroll_actions ppa

917: paa.tax_unit_id tax_unit_id,
918: ppa.effective_date effective_end_date
919: FROM per_all_assignments_f ASG,
920: pay_assignment_actions paa,
921: pay_payroll_actions ppa
922: WHERE ppa.effective_date between l_period_start
923: and l_period_end
924: and ppa.action_type in ('R', 'Q', 'V', 'B', 'I')
925: and paa.payroll_action_id = ppa.payroll_action_id

Line 958: pay_payroll_actions ppa,

954: paa.tax_unit_id tax_unit_id,
955: ppa.effective_date effective_end_date
956: FROM per_all_assignments_f ASG,
957: pay_assignment_actions paa,
958: pay_payroll_actions ppa,
959: pay_population_ranges ppr
960: WHERE ppa.effective_date between l_period_start
961: and l_period_end
962: and ppa.action_type in ('R', 'Q', 'V', 'B', 'I')

Line 997: pay_payroll_actions ppa,

993: paa.tax_unit_id tax_unit_id,
994: ppa.effective_date effective_end_date
995: FROM per_all_assignments_f ASG,
996: pay_assignment_actions paa,
997: pay_payroll_actions ppa,
998: hr_organization_information HOI_PR
999: WHERE ppa.effective_date between l_period_start and l_period_end
1000: AND ppa.action_type in ('R', 'Q', 'V', 'B', 'I')
1001: AND paa.payroll_action_id = ppa.payroll_action_id

Line 1044: pay_payroll_actions ppa,

1040: paa.tax_unit_id tax_unit_id,
1041: ppa.effective_date effective_end_date
1042: FROM per_all_assignments_f ASG,
1043: pay_assignment_actions paa,
1044: pay_payroll_actions ppa,
1045: hr_organization_information HOI_PR,
1046: pay_population_ranges ppr
1047: WHERE ppa.effective_date between l_period_start and l_period_end
1048: AND ppa.action_type in ('R', 'Q', 'V', 'B', 'I')

Line 1126: from pay_payroll_actions

1122: l_report_type,
1123: l_state,
1124: l_report_cat,
1125: l_bus_group_id
1126: from pay_payroll_actions
1127: where payroll_action_id = pactid;
1128:
1129:
1130: hr_utility.set_location ('actio_creation',1);

Line 1523: from pay_payroll_actions

1519: select report_qualifier,
1520: report_category
1521: into l_state,
1522: l_report_cat
1523: from pay_payroll_actions
1524: where payroll_action_id = p_payroll_action_id;
1525:
1526: /* Added the select of report_category field in the above SQL on
1527: 10-FEB-2000 by Ashu Gupta (ashgupta) */

Line 1716: from pay_payroll_actions

1712: /* Start Position of State */
1713: select INSTR(legislative_parameters,'TRANSFER_STATE=')
1714: + LENGTH('TRANSFER_STATE=')
1715: into l_from
1716: from pay_payroll_actions
1717: where payroll_action_id = p_payroll_action_id;
1718:
1719:
1720: /* End position of state in legislative parameters */

Line 1723: from pay_payroll_actions

1719:
1720: /* End position of state in legislative parameters */
1721: select INSTR(legislative_parameters,'TRANSFER_REPORTING_YEAR=')
1722: into l_to
1723: from pay_payroll_actions
1724: where payroll_action_id = p_payroll_action_id;
1725:
1726: l_length := l_to - l_from - 1 ;
1727:

Line 1733: from pay_payroll_actions

1729: into l_state_code
1730: from pay_us_states
1731: where state_abbrev = (
1732: select substr(legislative_parameters,l_from, l_length )
1733: from pay_payroll_actions
1734: where payroll_action_id = p_payroll_action_id);
1735:
1736: /* Archive the Taxable wage Base */
1737:

Line 1746: pay_payroll_actions ppa

1742: begin
1743: select to_char(sti.sui_er_wage_limit)
1744: into l_value
1745: from pay_us_state_tax_info_f sti,
1746: pay_payroll_actions ppa
1747: where ppa.payroll_action_id = p_payroll_action_id
1748: and sti.state_code = l_state_code
1749: and ppa.effective_date between sti.effective_start_date
1750: and sti.effective_end_date

Line 1947: -- FROM pay_payroll_actions ppa1,

1943: -- AND paei.aei_information1 = g_sqwl_state
1944: -- AND paei.information_type = 'PAY_US_ASG_STATE_WAGE_PLAN_CD'
1945: -- AND EXISTS(
1946: -- SELECT NULL
1947: -- FROM pay_payroll_actions ppa1,
1948: -- pay_assignment_actions paa1,
1949: -- pay_us_asg_reporting puar1
1950: -- WHERE paa1.assignment_id = paf1.assignment_id
1951: -- AND ppa1.payroll_action_id = paa1.payroll_action_id

Line 1997: -- FROM pay_payroll_actions ppa1,

1993: -- AND paei.aei_information1(+) = g_sqwl_state
1994: -- AND paei.information_type(+) = 'PAY_US_ASG_STATE_WAGE_PLAN_CD'
1995: -- AND EXISTS(
1996: -- SELECT NULL
1997: -- FROM pay_payroll_actions ppa1,
1998: -- pay_assignment_actions paa1,
1999: -- pay_us_asg_reporting puar1
2000: -- WHERE paa1.assignment_id = paf1.assignment_id
2001: -- AND ppa1.payroll_action_id = paa1.payroll_action_id

Line 2046: pay_payroll_actions ppa,

2042: select paa.assignment_action_id,
2043: ppa.effective_date
2044: from pay_assignment_actions paa,
2045: per_all_assignments_f paf,
2046: pay_payroll_actions ppa,
2047: pay_action_classifications pac,
2048: per_all_assignments_f paf1
2049: where paf1.assignment_id = p_assignment_id
2050: and paf.person_id = paf1.person_id

Line 2079: PAY_PAYROLL_ACTIONS PPA ,

2075: PPA.EFFECTIVE_DATE
2076: FROM PER_ALL_ASSIGNMENTS_F PAF1,
2077: PER_ALL_ASSIGNMENTS_F PAF ,
2078: PAY_ASSIGNMENT_ACTIONS PAA,
2079: PAY_PAYROLL_ACTIONS PPA ,
2080: PAY_ACTION_CLASSIFICATIONS PAC
2081: WHERE PAF1.ASSIGNMENT_ID = p_assignment_id
2082: AND PAF.PERSON_ID = PAF1.PERSON_ID
2083: AND PAA.ASSIGNMENT_ID = PAF.ASSIGNMENT_ID

Line 2324: /* Modifying to select effective_date from pay_payroll_actions corrsponding to

2320: /* End Bug 976472 */
2321:
2322: /* To get person level balances you must use the highest assignment action
2323: of the last paid assignment */
2324: /* Modifying to select effective_date from pay_payroll_actions corrsponding to
2325: the assignment action selected to solve th e new York SQWL 4th quarter problem */
2326:
2327: --Bug 3331021 : Remove Query with Rule hint and added cursor c_get_latest_asg
2328:

Line 2336: from pay_payroll_actions

2332: select effective_date,
2333: start_date
2334: into l_period_end,
2335: l_period_start
2336: from pay_payroll_actions
2337: where payroll_action_id = l_payroll_action_id;
2338:
2339:
2340: begin

Line 2407: pay_payroll_actions ppa

2403: )
2404: and ffai.context1 in (
2405: select paa.assignment_action_id
2406: from pay_assignment_actions paa,
2407: pay_payroll_actions ppa
2408: where ppa.payroll_action_id = paa.payroll_action_id
2409: and ppa.report_type = 'SQWL'
2410: and ppa.report_qualifier = 'NY'
2411: and ppa.payroll_action_id = to_number(p_payroll_action_id)

Line 2443: l_bus_group_id pay_payroll_actions.business_group_id%type,

2439: (
2440: l_pactid NUMBER ,
2441: l_period_start DATE ,
2442: l_period_end DATE ,
2443: l_bus_group_id pay_payroll_actions.business_group_id%type,
2444: l_state VARCHAR2,
2445: l_report_cat VARCHAR2
2446: )
2447: RETURN BOOLEAN IS

Line 2591: , pay_payroll_actions PACT

2587: ,p_mon_of_qtr number) IS
2588: SELECT ASG.LOCATION_ID
2589: FROM per_assignments_f ASG
2590: , pay_assignment_actions ASSACT
2591: , pay_payroll_actions PACT
2592: WHERE ASSACT.assignment_action_id = p_ass_act_id
2593: AND ASSACT.payroll_action_id = PACT.payroll_action_id
2594: AND ASSACT.assignment_id = ASG.assignment_id
2595: AND add_months(trunc (PACT.effective_date, 'Q'), p_mon_of_qtr - 1) + 11

Line 2613: pay_payroll_actions ppa

2609: /*Commenting for bug 2510853
2610: SELECT paf.location_id
2611: FROM per_assignments_f paf,
2612: pay_assignment_actions paa,
2613: pay_payroll_actions ppa
2614: WHERE (paa.assignment_action_id = p_ass_acti_id
2615: AND paa.payroll_action_id = ppa.payroll_action_id
2616: AND paa.assignment_id = paf.assignment_id
2617: AND ppa.business_group_id = paf.business_group_id

Line 2638: pay_payroll_actions ppa

2634:
2635: SELECT paf.location_id
2636: FROM per_assignments_f paf,
2637: pay_assignment_actions paa,
2638: pay_payroll_actions ppa
2639: WHERE paa.assignment_action_id = p_ass_acti_id
2640: AND paa.payroll_action_id = ppa.payroll_action_id
2641: AND paa.assignment_id = paf.assignment_id
2642: -- commenting the redundant join with business group id for bug 2809506

Line 2781: l_state pay_payroll_actions.report_qualifier%type;

2777: Notes :
2778: */
2779:
2780: procedure range_cursor (pactid in number, sqlstr out nocopy varchar2) is
2781: l_state pay_payroll_actions.report_qualifier%type;
2782: l_report_cat pay_payroll_actions.report_category%type;
2783: l_effective_date pay_payroll_actions.effective_date%type;
2784: l_start_date pay_payroll_actions.start_date%type;
2785: l_business_group_id pay_payroll_actions.business_group_id%type;

Line 2782: l_report_cat pay_payroll_actions.report_category%type;

2778: */
2779:
2780: procedure range_cursor (pactid in number, sqlstr out nocopy varchar2) is
2781: l_state pay_payroll_actions.report_qualifier%type;
2782: l_report_cat pay_payroll_actions.report_category%type;
2783: l_effective_date pay_payroll_actions.effective_date%type;
2784: l_start_date pay_payroll_actions.start_date%type;
2785: l_business_group_id pay_payroll_actions.business_group_id%type;
2786:

Line 2783: l_effective_date pay_payroll_actions.effective_date%type;

2779:
2780: procedure range_cursor (pactid in number, sqlstr out nocopy varchar2) is
2781: l_state pay_payroll_actions.report_qualifier%type;
2782: l_report_cat pay_payroll_actions.report_category%type;
2783: l_effective_date pay_payroll_actions.effective_date%type;
2784: l_start_date pay_payroll_actions.start_date%type;
2785: l_business_group_id pay_payroll_actions.business_group_id%type;
2786:
2787: /* Bug 773937 */

Line 2784: l_start_date pay_payroll_actions.start_date%type;

2780: procedure range_cursor (pactid in number, sqlstr out nocopy varchar2) is
2781: l_state pay_payroll_actions.report_qualifier%type;
2782: l_report_cat pay_payroll_actions.report_category%type;
2783: l_effective_date pay_payroll_actions.effective_date%type;
2784: l_start_date pay_payroll_actions.start_date%type;
2785: l_business_group_id pay_payroll_actions.business_group_id%type;
2786:
2787: /* Bug 773937 */
2788: l_tax_unit_id number;

Line 2785: l_business_group_id pay_payroll_actions.business_group_id%type;

2781: l_state pay_payroll_actions.report_qualifier%type;
2782: l_report_cat pay_payroll_actions.report_category%type;
2783: l_effective_date pay_payroll_actions.effective_date%type;
2784: l_start_date pay_payroll_actions.start_date%type;
2785: l_business_group_id pay_payroll_actions.business_group_id%type;
2786:
2787: /* Bug 773937 */
2788: l_tax_unit_id number;
2789: l_archive boolean:= FALSE;

Line 2824: FROM pay_payroll_actions

2820: l_report_cat,
2821: l_effective_date,
2822: l_start_date,
2823: l_business_group_id
2824: FROM pay_payroll_actions
2825: WHERE payroll_action_id = pactid;
2826:
2827: hr_utility.trace('Selected from pay_payroll_actions ');
2828:

Line 2827: hr_utility.trace('Selected from pay_payroll_actions ');

2823: l_business_group_id
2824: FROM pay_payroll_actions
2825: WHERE payroll_action_id = pactid;
2826:
2827: hr_utility.trace('Selected from pay_payroll_actions ');
2828:
2829: /* Bug 1220213 */
2830: /* If New York state and last quarter SQWL, then the date range is full year */
2831: if ( l_state = 'NY' and to_char(l_effective_date,'DD-MON') = '31-DEC' ) then

Line 2968: from pay_payroll_actions

2964: /* Select Tax unit Id from legislative parameters */
2965: select INSTR(legislative_parameters,'TRANSFER_TRANS_LEGAL_CO_ID=')
2966: + LENGTH('TRANSFER_TRANS_LEGAL_CO_ID=')
2967: into l_from
2968: from pay_payroll_actions
2969: where payroll_action_id = pactid;
2970:
2971: hr_utility.trace('l_from is '||to_char(l_from));
2972:

Line 2978: from pay_payroll_actions

2974: /* End position of state in legislative parameters */
2975:
2976: select INSTR(legislative_parameters,'TRANSFER_DATE=')
2977: into l_to
2978: from pay_payroll_actions
2979: where payroll_action_id = pactid;
2980:
2981: hr_utility.trace('l_to is '||to_char(l_to));
2982:

Line 2989: from pay_payroll_actions

2985: hr_utility.trace('l_length is '||to_char(l_length));
2986:
2987: select fnd_number.canonical_to_number(substr(legislative_parameters, l_from , l_length ))
2988: into l_tax_unit_id
2989: from pay_payroll_actions
2990: where payroll_action_id = pactid;
2991:
2992: hr_utility.trace('Transmitter GRS is '||to_char(l_tax_unit_id));
2993: hr_utility.trace('Report Category is '||l_report_cat);