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 256: add the context of pay_payroll_actions

252: A_SS_EE_WAGE rate to archive the data
253: related to bug 983094 and 101435
254:
255: 01-sep-1999 achauhan While archiving the employer data
256: add the context of pay_payroll_actions
257: to ff_archive_item_contexts.
258: 11-aug-1999 achauhan Added the call to
259: eoy_archive_gre_data in the
260: eoy_range_cursor procedure. This is

Line 769: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;

765: /* Variables used to hold the details of the payroll and assignment actions
766: that are created. */
767:
768: l_payroll_action_created boolean := false;
769: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
770: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
771:
772:
773: /* Variable holding the balance to be tested. */

Line 807: l_report_type pay_payroll_actions.report_type%type;

803: l_jurisdiction_code varchar2(30);
804:
805: /* general process variables */
806:
807: l_report_type pay_payroll_actions.report_type%type;
808: l_report_cat pay_payroll_actions.report_category%type;
809: l_state pay_payroll_actions.report_qualifier%type;
810: l_report_format pay_report_format_mappings_f.report_format%type; -- Bug# 3843134
811: l_value number;

Line 808: l_report_cat pay_payroll_actions.report_category%type;

804:
805: /* general process variables */
806:
807: l_report_type pay_payroll_actions.report_type%type;
808: l_report_cat pay_payroll_actions.report_category%type;
809: l_state pay_payroll_actions.report_qualifier%type;
810: l_report_format pay_report_format_mappings_f.report_format%type; -- Bug# 3843134
811: l_value number;
812: l_value_sit number ; --4310812

Line 809: l_state pay_payroll_actions.report_qualifier%type;

805: /* general process variables */
806:
807: l_report_type pay_payroll_actions.report_type%type;
808: l_report_cat pay_payroll_actions.report_category%type;
809: l_state pay_payroll_actions.report_qualifier%type;
810: l_report_format pay_report_format_mappings_f.report_format%type; -- Bug# 3843134
811: l_value number;
812: l_value_sit number ; --4310812
813: l_person_on boolean ; --4349864

Line 834: pay_payroll_actions ppa

830: paa.tax_unit_id tax_unit_id,
831: ppa.effective_date effective_end_date
832: FROM per_all_assignments_f ASG,
833: pay_assignment_actions paa,
834: pay_payroll_actions ppa
835: WHERE ppa.effective_date between l_period_start
836: and l_period_end
837: and ppa.action_type in ('R', 'Q', 'V', 'B', 'I')
838: and paa.payroll_action_id = ppa.payroll_action_id

Line 872: pay_payroll_actions ppa,

868: paa.tax_unit_id tax_unit_id,
869: ppa.effective_date effective_end_date
870: FROM per_all_assignments_f ASG,
871: pay_assignment_actions paa,
872: pay_payroll_actions ppa,
873: pay_population_ranges ppr
874: WHERE ppa.effective_date between l_period_start
875: and l_period_end
876: and ppa.action_type in ('R', 'Q', 'V', 'B', 'I')

Line 911: pay_payroll_actions ppa

907: paa.tax_unit_id tax_unit_id,
908: ppa.effective_date effective_end_date
909: FROM per_all_assignments_f ASG,
910: pay_assignment_actions paa,
911: pay_payroll_actions ppa
912: WHERE ppa.effective_date between l_period_start
913: and l_period_end
914: and ppa.action_type in ('R', 'Q', 'V', 'B', 'I')
915: and paa.payroll_action_id = ppa.payroll_action_id

Line 949: pay_payroll_actions ppa,

945: paa.tax_unit_id tax_unit_id,
946: ppa.effective_date effective_end_date
947: FROM per_all_assignments_f ASG,
948: pay_assignment_actions paa,
949: pay_payroll_actions ppa,
950: pay_population_ranges ppr
951: WHERE ppa.effective_date between l_period_start
952: and l_period_end
953: and ppa.action_type in ('R', 'Q', 'V', 'B', 'I')

Line 991: pay_payroll_actions ppa

987: paa.tax_unit_id tax_unit_id,
988: ppa.effective_date effective_end_date
989: FROM per_all_assignments_f ASG,
990: pay_assignment_actions paa,
991: pay_payroll_actions ppa
992: WHERE ppa.effective_date between l_period_start
993: and l_period_end
994: and ppa.action_type in ('R', 'Q', 'V', 'B', 'I')
995: and paa.payroll_action_id = ppa.payroll_action_id

Line 1028: pay_payroll_actions ppa,

1024: paa.tax_unit_id tax_unit_id,
1025: ppa.effective_date effective_end_date
1026: FROM per_all_assignments_f ASG,
1027: pay_assignment_actions paa,
1028: pay_payroll_actions ppa,
1029: pay_population_ranges ppr
1030: WHERE ppa.effective_date between l_period_start
1031: and l_period_end
1032: and ppa.action_type in ('R', 'Q', 'V', 'B', 'I')

Line 1067: pay_payroll_actions ppa,

1063: paa.tax_unit_id tax_unit_id,
1064: ppa.effective_date effective_end_date
1065: FROM per_all_assignments_f ASG,
1066: pay_assignment_actions paa,
1067: pay_payroll_actions ppa,
1068: hr_organization_information HOI_PR
1069: WHERE ppa.effective_date between l_period_start and l_period_end
1070: AND ppa.action_type in ('R', 'Q', 'V', 'B', 'I')
1071: AND paa.payroll_action_id = ppa.payroll_action_id

Line 1114: pay_payroll_actions ppa,

1110: paa.tax_unit_id tax_unit_id,
1111: ppa.effective_date effective_end_date
1112: FROM per_all_assignments_f ASG,
1113: pay_assignment_actions paa,
1114: pay_payroll_actions ppa,
1115: hr_organization_information HOI_PR,
1116: pay_population_ranges ppr
1117: WHERE ppa.effective_date between l_period_start and l_period_end
1118: AND ppa.action_type in ('R', 'Q', 'V', 'B', 'I')

Line 1196: from pay_payroll_actions

1192: l_report_type,
1193: l_state,
1194: l_report_cat,
1195: l_bus_group_id
1196: from pay_payroll_actions
1197: where payroll_action_id = pactid;
1198:
1199:
1200: hr_utility.set_location ('actio_creation',1);

Line 1403: FROM pay_payroll_actions

1399:
1400: BEGIN
1401: SELECT pay_us_payroll_utils.get_parameter('TRANSFER_GRE',legislative_parameters)
1402: INTO l_transfer_gre_id
1403: FROM pay_payroll_actions
1404: WHERE payroll_action_id = pactid;
1405: EXCEPTION
1406: WHEN no_data_found then
1407: l_transfer_gre_id := NULL;

Line 1556: FROM pay_payroll_actions

1552: --
1553:
1554: SELECT pay_us_payroll_utils.get_parameter('TRANSFER_GRE',legislative_parameters)
1555: INTO l_transfer_gre_id
1556: FROM pay_payroll_actions
1557: WHERE payroll_action_id = pactid;
1558:
1559: hr_utility.set_location ('actio_creation',8);
1560: -- insert into pay_assignment_actions.

Line 1622: from pay_payroll_actions

1618: select report_qualifier,
1619: report_category
1620: into l_state,
1621: l_report_cat
1622: from pay_payroll_actions
1623: where payroll_action_id = p_payroll_action_id;
1624:
1625: /* Added the select of report_category field in the above SQL on
1626: 10-FEB-2000 by Ashu Gupta (ashgupta) */

Line 1815: from pay_payroll_actions

1811: /* Start Position of State */
1812: select INSTR(legislative_parameters,'TRANSFER_STATE=')
1813: + LENGTH('TRANSFER_STATE=')
1814: into l_from
1815: from pay_payroll_actions
1816: where payroll_action_id = p_payroll_action_id;
1817:
1818:
1819: /* End position of state in legislative parameters */

Line 1822: from pay_payroll_actions

1818:
1819: /* End position of state in legislative parameters */
1820: select INSTR(legislative_parameters,'TRANSFER_REPORTING_YEAR=')
1821: into l_to
1822: from pay_payroll_actions
1823: where payroll_action_id = p_payroll_action_id;
1824:
1825: l_length := l_to - l_from - 1 ;
1826:

Line 1832: from pay_payroll_actions

1828: into l_state_code
1829: from pay_us_states
1830: where state_abbrev = (
1831: select substr(legislative_parameters,l_from, l_length )
1832: from pay_payroll_actions
1833: where payroll_action_id = p_payroll_action_id);
1834:
1835: /* Archive the Taxable wage Base */
1836:

Line 1845: pay_payroll_actions ppa

1841: begin
1842: select to_char(sti.sui_er_wage_limit)
1843: into l_value
1844: from pay_us_state_tax_info_f sti,
1845: pay_payroll_actions ppa
1846: where ppa.payroll_action_id = p_payroll_action_id
1847: and sti.state_code = l_state_code
1848: and ppa.effective_date between sti.effective_start_date
1849: and sti.effective_end_date

Line 2045: -- FROM pay_payroll_actions ppa1,

2041: -- AND paei.aei_information1 = g_sqwl_state
2042: -- AND paei.information_type = 'PAY_US_ASG_STATE_WAGE_PLAN_CD'
2043: -- AND EXISTS(
2044: -- SELECT NULL
2045: -- FROM pay_payroll_actions ppa1,
2046: -- pay_assignment_actions paa1,
2047: -- pay_us_asg_reporting puar1
2048: -- WHERE paa1.assignment_id = paf1.assignment_id
2049: -- AND ppa1.payroll_action_id = paa1.payroll_action_id

Line 2095: -- FROM pay_payroll_actions ppa1,

2091: -- AND paei.aei_information1(+) = g_sqwl_state
2092: -- AND paei.information_type(+) = 'PAY_US_ASG_STATE_WAGE_PLAN_CD'
2093: -- AND EXISTS(
2094: -- SELECT NULL
2095: -- FROM pay_payroll_actions ppa1,
2096: -- pay_assignment_actions paa1,
2097: -- pay_us_asg_reporting puar1
2098: -- WHERE paa1.assignment_id = paf1.assignment_id
2099: -- AND ppa1.payroll_action_id = paa1.payroll_action_id

Line 2144: pay_payroll_actions ppa,

2140: select paa.assignment_action_id,
2141: ppa.effective_date
2142: from pay_assignment_actions paa,
2143: per_all_assignments_f paf,
2144: pay_payroll_actions ppa,
2145: pay_action_classifications pac,
2146: per_all_assignments_f paf1
2147: where paf1.assignment_id = p_assignment_id
2148: and paf.person_id = paf1.person_id

Line 2177: PAY_PAYROLL_ACTIONS PPA ,

2173: PPA.EFFECTIVE_DATE
2174: FROM PER_ALL_ASSIGNMENTS_F PAF1,
2175: PER_ALL_ASSIGNMENTS_F PAF ,
2176: PAY_ASSIGNMENT_ACTIONS PAA,
2177: PAY_PAYROLL_ACTIONS PPA ,
2178: PAY_ACTION_CLASSIFICATIONS PAC
2179: WHERE PAF1.ASSIGNMENT_ID = p_assignment_id
2180: AND PAF.PERSON_ID = PAF1.PERSON_ID
2181: AND PAA.ASSIGNMENT_ID = PAF.ASSIGNMENT_ID

Line 2241: pay_payroll_actions ppa

2237: CURSOR get_previous_fl_taxable IS
2238: select sum(to_number(nvl(value,'0')))
2239: from ff_archive_items ffai,
2240: pay_assignment_actions paa,
2241: pay_payroll_actions ppa
2242: where ffai.user_entity_id = l_user_entity_id
2243: and ffai.context1=to_char(paa.assignment_action_id)
2244: and paa.tax_unit_id = taxunitid
2245: and paa.payroll_action_id = ppa.payroll_action_id

Line 2265: assignment to fetch the balances.This we do by referring to the pay_payroll_actions

2261: /*Since we are using the Date Based approach to fetch the Balances
2262: of the assignment, we need to ensure that on the Date we pass for the
2263: assignment, the Assignment record is present.Incase, the employee
2264: is terminated, we need to pass the last effective date applicable to the
2265: assignment to fetch the balances.This we do by referring to the pay_payroll_actions
2266: table to find the maximum effective_date of this person in this Quarter.*/
2267:
2268: CURSOR get_effective_date (p_quarter_start_date DATE,
2269: p_quarter_end_date DATE) IS

Line 2273: pay_payroll_actions ppa

2269: p_quarter_end_date DATE) IS
2270: select max(ppa.effective_date)
2271: from per_all_assignments_f asg,
2272: pay_assignment_actions paa,
2273: pay_payroll_actions ppa
2274: where ppa.effective_date between p_quarter_start_date
2275: and p_quarter_end_date
2276: and ppa.action_type in ('R', 'Q', 'V', 'B', 'I')
2277: and paa.payroll_action_id = ppa.payroll_action_id

Line 2312: pay_payroll_actions ppa

2308: CURSOR get_previous_ar_value(l_user_entity_id IN NUMBER) IS
2309: select sum(to_number(nvl(value,'0')))
2310: from ff_archive_items ffai,
2311: pay_assignment_actions paa,
2312: pay_payroll_actions ppa
2313: where ffai.user_entity_id = l_user_entity_id
2314: and ffai.context1=to_char(paa.assignment_action_id)
2315: and paa.tax_unit_id = taxunitid
2316: and paa.payroll_action_id = ppa.payroll_action_id

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

3253: /* End Bug 976472 */
3254:
3255: /* To get person level balances you must use the highest assignment action
3256: of the last paid assignment */
3257: /* Modifying to select effective_date from pay_payroll_actions corrsponding to
3258: the assignment action selected to solve th e new York SQWL 4th quarter problem */
3259:
3260: --Bug 3331021 : Remove Query with Rule hint and added cursor c_get_latest_asg
3261:

Line 3269: from pay_payroll_actions

3265: select effective_date,
3266: start_date
3267: into l_period_end,
3268: l_period_start
3269: from pay_payroll_actions
3270: where payroll_action_id = l_payroll_action_id;
3271:
3272:
3273: begin

Line 3344: pay_payroll_actions ppa

3340: )
3341: and ffai.context1 in (
3342: select paa.assignment_action_id
3343: from pay_assignment_actions paa,
3344: pay_payroll_actions ppa
3345: where ppa.payroll_action_id = paa.payroll_action_id
3346: and ppa.report_type = 'SQWL'
3347: and ppa.report_qualifier = 'NY'
3348: and ppa.payroll_action_id = to_number(p_payroll_action_id)

Line 3380: l_bus_group_id pay_payroll_actions.business_group_id%type,

3376: (
3377: l_pactid NUMBER ,
3378: l_period_start DATE ,
3379: l_period_end DATE ,
3380: l_bus_group_id pay_payroll_actions.business_group_id%type,
3381: l_state VARCHAR2,
3382: l_report_cat VARCHAR2
3383: )
3384: RETURN BOOLEAN IS

Line 3528: , pay_payroll_actions PACT

3524: ,p_mon_of_qtr number) IS
3525: SELECT ASG.LOCATION_ID
3526: FROM per_assignments_f ASG
3527: , pay_assignment_actions ASSACT
3528: , pay_payroll_actions PACT
3529: WHERE ASSACT.assignment_action_id = p_ass_act_id
3530: AND ASSACT.payroll_action_id = PACT.payroll_action_id
3531: AND ASSACT.assignment_id = ASG.assignment_id
3532: AND add_months(trunc (PACT.effective_date, 'Q'), p_mon_of_qtr - 1) + 11

Line 3541: , pay_payroll_actions PACT

3537: ,p_mon_of_qtr number) IS
3538: SELECT ASG.LOCATION_ID
3539: FROM per_assignments_f ASG
3540: , pay_assignment_actions ASSACT
3541: , pay_payroll_actions PACT
3542: WHERE ASSACT.assignment_action_id = p_ass_act_id
3543: AND ASSACT.payroll_action_id = PACT.payroll_action_id
3544: AND ASSACT.assignment_id = ASG.assignment_id
3545: AND ( add_months(trunc (PACT.effective_date, 'Q'), p_mon_of_qtr - 1)

Line 3567: pay_payroll_actions ppa

3563: /*Commenting for bug 2510853
3564: SELECT paf.location_id
3565: FROM per_assignments_f paf,
3566: pay_assignment_actions paa,
3567: pay_payroll_actions ppa
3568: WHERE (paa.assignment_action_id = p_ass_acti_id
3569: AND paa.payroll_action_id = ppa.payroll_action_id
3570: AND paa.assignment_id = paf.assignment_id
3571: AND ppa.business_group_id = paf.business_group_id

Line 3592: pay_payroll_actions ppa

3588:
3589: SELECT paf.location_id
3590: FROM per_assignments_f paf,
3591: pay_assignment_actions paa,
3592: pay_payroll_actions ppa
3593: WHERE paa.assignment_action_id = p_ass_acti_id
3594: AND paa.payroll_action_id = ppa.payroll_action_id
3595: AND paa.assignment_id = paf.assignment_id
3596: -- commenting the redundant join with business group id for bug 2809506

Line 3745: l_state pay_payroll_actions.report_qualifier%type;

3741: Notes :
3742: */
3743:
3744: procedure range_cursor (pactid in number, sqlstr out nocopy varchar2) is
3745: l_state pay_payroll_actions.report_qualifier%type;
3746: l_report_cat pay_payroll_actions.report_category%type;
3747: l_effective_date pay_payroll_actions.effective_date%type;
3748: l_start_date pay_payroll_actions.start_date%type;
3749: l_business_group_id pay_payroll_actions.business_group_id%type;

Line 3746: l_report_cat pay_payroll_actions.report_category%type;

3742: */
3743:
3744: procedure range_cursor (pactid in number, sqlstr out nocopy varchar2) is
3745: l_state pay_payroll_actions.report_qualifier%type;
3746: l_report_cat pay_payroll_actions.report_category%type;
3747: l_effective_date pay_payroll_actions.effective_date%type;
3748: l_start_date pay_payroll_actions.start_date%type;
3749: l_business_group_id pay_payroll_actions.business_group_id%type;
3750:

Line 3747: l_effective_date pay_payroll_actions.effective_date%type;

3743:
3744: procedure range_cursor (pactid in number, sqlstr out nocopy varchar2) is
3745: l_state pay_payroll_actions.report_qualifier%type;
3746: l_report_cat pay_payroll_actions.report_category%type;
3747: l_effective_date pay_payroll_actions.effective_date%type;
3748: l_start_date pay_payroll_actions.start_date%type;
3749: l_business_group_id pay_payroll_actions.business_group_id%type;
3750:
3751: /* Bug 773937 */

Line 3748: l_start_date pay_payroll_actions.start_date%type;

3744: procedure range_cursor (pactid in number, sqlstr out nocopy varchar2) is
3745: l_state pay_payroll_actions.report_qualifier%type;
3746: l_report_cat pay_payroll_actions.report_category%type;
3747: l_effective_date pay_payroll_actions.effective_date%type;
3748: l_start_date pay_payroll_actions.start_date%type;
3749: l_business_group_id pay_payroll_actions.business_group_id%type;
3750:
3751: /* Bug 773937 */
3752: l_tax_unit_id number;

Line 3749: l_business_group_id pay_payroll_actions.business_group_id%type;

3745: l_state pay_payroll_actions.report_qualifier%type;
3746: l_report_cat pay_payroll_actions.report_category%type;
3747: l_effective_date pay_payroll_actions.effective_date%type;
3748: l_start_date pay_payroll_actions.start_date%type;
3749: l_business_group_id pay_payroll_actions.business_group_id%type;
3750:
3751: /* Bug 773937 */
3752: l_tax_unit_id number;
3753: l_gre number;

Line 3772: l_parent_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;

3768: -- The l_preprocess_flag variable was added by Ashu Gupta (ashgupta)
3769: -- on 08-FEB-2000 to check if any person has an invalid wage plan code
3770:
3771: l_preprocess_flag BOOLEAN := FALSE;
3772: l_parent_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
3773:
3774: cursor c_reporting_rules(cp_tax_unit_id in number) is
3775: select '1' from hr_organization_information
3776: where organization_id = cp_tax_unit_id

Line 3790: FROM pay_payroll_actions

3786: l_report_cat,
3787: l_effective_date,
3788: l_start_date,
3789: l_business_group_id
3790: FROM pay_payroll_actions
3791: WHERE payroll_action_id = pactid;
3792:
3793: hr_utility.trace('Selected from pay_payroll_actions ');
3794:

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

3789: l_business_group_id
3790: FROM pay_payroll_actions
3791: WHERE payroll_action_id = pactid;
3792:
3793: hr_utility.trace('Selected from pay_payroll_actions ');
3794:
3795: /* bug: 10649380 : code to check parent payroll action, this code has been added to stop the use
3796: of old sqwl process "State Quarterly Wage Listing", customer need use
3797: new enhanced SQWL Process.

Line 3802: FROM pay_payroll_actions

3798: */
3799:
3800: SELECT pay_us_payroll_utils.get_parameter('TRANSFER_PARENT_PAYROLL_ACTION',legislative_parameters)
3801: INTO l_parent_payroll_action_id
3802: FROM pay_payroll_actions
3803: WHERE payroll_action_id = pactid;
3804: hr_utility.trace('l_parent_payroll_action_id '||l_parent_payroll_action_id);
3805:
3806: IF l_parent_payroll_action_id is NULL THEN

Line 3816: FROM pay_payroll_actions

3812: END IF;
3813:
3814: SELECT pay_us_payroll_utils.get_parameter('TRANSFER_GRE',legislative_parameters)
3815: INTO l_gre
3816: FROM pay_payroll_actions
3817: WHERE payroll_action_id = pactid;
3818:
3819: hr_utility.trace('Transferr GRE is '||to_char(l_gre));
3820: hr_utility.trace('Report Category is '||l_report_cat);

Line 3964: from pay_payroll_actions

3960: /* Select Tax unit Id from legislative parameters */
3961: select INSTR(legislative_parameters,'TRANSFER_TRANS_LEGAL_CO_ID=')
3962: + LENGTH('TRANSFER_TRANS_LEGAL_CO_ID=')
3963: into l_from
3964: from pay_payroll_actions
3965: where payroll_action_id = pactid;
3966:
3967: hr_utility.trace('l_from is '||to_char(l_from));
3968:

Line 3974: from pay_payroll_actions

3970: /* End position of state in legislative parameters */
3971:
3972: select INSTR(legislative_parameters,'TRANSFER_DATE=')
3973: into l_to
3974: from pay_payroll_actions
3975: where payroll_action_id = pactid;
3976:
3977: hr_utility.trace('l_to is '||to_char(l_to));
3978:

Line 3985: from pay_payroll_actions

3981: hr_utility.trace('l_length is '||to_char(l_length));
3982:
3983: select fnd_number.canonical_to_number(substr(legislative_parameters, l_from , l_length ))
3984: into l_tax_unit_id
3985: from pay_payroll_actions
3986: where payroll_action_id = pactid;
3987:
3988: hr_utility.trace('Transmitter GRS is '||to_char(l_tax_unit_id));
3989: hr_utility.trace('Report Category is '||l_report_cat);