APPS.PAY_AE_PAYROLL_REGISTER dependencies on PAY_EMEA_PAYMENT_VALUES_V

Line 561: pay_emea_payment_values_v pet

557: pay_assignment_actions paa1,
558: pay_assignment_actions paa2,
559: pay_payroll_actions ppa,
560: pay_action_information pai,
561: pay_emea_payment_values_v pet
562: WHERE
563: lck.locked_action_id = paa1.assignment_action_id AND
564: paa1.source_action_id IS NULL AND
565: paa1.payroll_action_id = ppa.payroll_action_id AND

Line 609: pay_emea_payment_values_v pet

605: pay_assignment_actions paa1,
606: pay_assignment_actions paa2,
607: pay_payroll_actions ppa,
608: pay_action_information pai,
609: pay_emea_payment_values_v pet
610: WHERE
611: lck.locked_action_id = paa1.assignment_action_id AND
612: paa1.source_action_id IS NULL AND
613: paa1.payroll_action_id = ppa.payroll_action_id AND

Line 696: pay_emea_payment_values_v pet,

692: AND paa1.action_status = 'C'
693: AND ptp.end_date = l_effective_date);*/
694: SELECT sum(pet.result_value)
695: FROM pay_action_information pai_ele,
696: pay_emea_payment_values_v pet,
697: pay_assignment_actions paa
698: WHERE paa.payroll_action_id = pai_ele.action_context_id
699: AND pai_ele.action_context_type = 'PA'
700: AND pai_ele.action_information_category = 'EMEA ELEMENT DEFINITION'

Line 837: ,pay_emea_payment_values_v pet

833: and pay_v.payment_type not in ('F')
834: and paa.assignment_action_id = l_arch_assact;*/
835: select SUM(pet.result_value)
836: from pay_action_information pai_ele
837: ,pay_emea_payment_values_v pet
838: ,pay_assignment_actions paa
839: where paa.payroll_action_id = pai_ele.action_context_id
840: and pai_ele.action_context_type = 'PA'
841: and pai_ele.action_information_category = 'EMEA ELEMENT DEFINITION'

Line 893: pay_emea_payment_values_v pet,

889: AND paa1.action_status = 'C'
890: AND ptp.end_date = l_effective_date);*/
891: SELECT sum(pet.result_value)
892: FROM pay_action_information pai_ele,
893: pay_emea_payment_values_v pet,
894: pay_assignment_actions paa
895: WHERE paa.payroll_action_id = pai_ele.action_context_id
896: AND pai_ele.action_context_type = 'PA'
897: AND pai_ele.action_information_category = 'EMEA ELEMENT DEFINITION'

Line 1032: ,pay_emea_payment_values_v pet

1028: and pay_v.payment_type not in ('F')
1029: and paa.assignment_action_id = l_arch_assact;*/
1030: select SUM(pet.result_value)
1031: from pay_action_information pai_ele
1032: ,pay_emea_payment_values_v pet
1033: ,pay_assignment_actions paa
1034: where paa.payroll_action_id = pai_ele.action_context_id
1035: and pai_ele.action_context_type = 'PA'
1036: and pai_ele.action_information_category = 'EMEA ELEMENT DEFINITION'